package com.clkj.xiuzheng.dao.shangcheng;

import com.clkj.xiuzheng.pojo.shangcheng.UserCommDetail;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

/**
 * @author yawang
 * @create 2024/05/22 14:11:16
 **/
@Repository
public interface UserCommDetailMapper extends Mapper<UserCommDetail> {

    @Select("select a.*,b.user_name,b.user_img from t_xz_userCommDetail a left join t_xz_user b on a.recharge_id = b.user_id  where a.user_id = #{userId}  ")
    List<UserCommDetail> listCommission(@Param("userId")Integer userId);
}
